/**
 * 
 */
package com.diy.excelsql.common;

/**
 * @author Hongten
 * @created 2014-5-18
 */
public class Common {

	// connect the database localhost
/*	public static final String DRIVER = "com.mysql.jdbc.Driver";
	public static final String DB_NAME = "test";
	public static final String USERNAME = "root";
	public static final String PASSWORD = "1";
	public static final String IP = "127.0.0.1";
	public static final String PORT = "3306";
	public static final String URL = "jdbc:mysql://" + IP + ":" + PORT + "/" + DB_NAME;*/
    // connect the database 199 dev
    public static final String DRIVER = "com.mysql.jdbc.Driver";
	public static final String DB_NAME = "llt_jdy_dev";
	public static final String USERNAME = "llt_jdy_dbuser";
	public static final String PASSWORD = "BupUcanubshoJHhd4dgl";
	public static final String IP = "47.97.160.199";
	public static final String PORT = "3306";
	public static final String URL = "jdbc:mysql://" + IP + ":" + PORT + "/" + DB_NAME + "?useUnicode=true&characterEncoding=utf8&useSSL=false";

	// common
	public static final String EXCEL_PATH = "src/main/resources/xls/student_info.xls";
	// FHL 的 测试代码
	public static final String EXCEL_PATH_FHL_TEST = "src/main/resources/xls/20180608卡bin信息test.xls.xls";
	public static final String EXCEL_PATH_FHL = "src/main/resources/xls/20180608卡bin信息.xls";

	// sql
	public static final String INSERT_STUDENT_SQL = "insert into student_info(no, name, age, score) values(?, ?, ?, ?)";
	public static final String UPDATE_STUDENT_SQL = "update student_info set no = ?, name = ?, age= ?, score = ? where id = ? ";
	public static final String SELECT_STUDENT_ALL_SQL = "select id,no,name,age,score from student_info";
	public static final String SELECT_STUDENT_SQL = "select * from student_info where name like ";

    public static final String SELECT_FHL_SQL = "select 1 from t_fhl_common_card_bin_info where ID= ";

	public static final String INSERT_FHL_SQL = "INSERT INTO t_fhl_common_card_bin_info\n" +
            "(ID, CARD_ISSUER_CODE, CARD_ISSUER_NAME, CARD_NAME, CARD_LENGTH, CARD_BIN, CARD_BIN_LENGTH, CARD_TYPE, CARD_START, CARD_END, CREATE_DATE)\n" +
            "VALUES(?, ?, ?, ?, ?, ?, ?, ?, '', '', CURRENT_TIMESTAMP);";
}
